1
2 <?php
3 include_once 'header.php';
4 ?>
5 <html>
6 <head>
7 <title>Dunkirk</title>
8 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
9
10 <!-- Optional theme -->
11 <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap-theme.min.css" integrity="sha384-rHyoN1iRsVXV4nD0JutlnGaslCJuC7uwjduW9SVrLvRYooPp2bWYgmgJQIXwl/Sp" crossorigin="anonymous">
12
13 <!-- Latest compiled and minified JavaScript -->
14 <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
15 </head>
16 <style>
17 table,th,td
18 {
19 border: 2px color:transparent;
20 font-family: monospace;
21 font-size: 150%;
22 padding: 0.25cm;
23 background-color: black;
24
25 }
26 body{
27 background-image: url("images/dunk1.jpg");
28 -moz-background-size: cover;
29 -webkit-background-size: cover;
30 -o-background-size: cover;
31 background-size: cover;
32 background-position: top center !important;
33 background-repeat: no-repeat !important;
34 background-attachment: fixed;
35 color: white;
36 }
37
38 button
39 {
40 display: block;
41 margin: 0 auto;
42 width: 10%;
43 height: 40px;
44 border: none;
45 background-color: #222;
46 font-family: arial;
47 font-size: 16px;
48 color: #fff;
49 cursor: pointer;
50 }
51 </style>
52
53
54
55 <head>
56 <h1 align="middle" style="font-size: 500%; color:black;"><b><u>Dunkirk</u></b></h1>
57 </head>
58
59
60
61 <body style="background-color: powderblue; font-family: monospace; margin: 0; padding: 0;">
62 <h1> </h1>
63 <p align=middle>
64 <video width="700" height="545" controls >
65 <source src="video/dunkirk.mp4" type="video/mp4">
66 </video>
67 <h1 align="middle" style="font-size: 300%; color:black;"><u><b>Trailer</b></u></h1>
68 </p>
69
70 <br><br><br><br>
71
72 <?php
73 $dbServername = "localhost";
74 $dbUsername = "root";
75 $dbPassword = "password";
76 $dbName = "test";
77
78 $conn = mysqli_connect($dbServername, $dbUsername, $dbPassword, $dbName);
79
80 $sql="SELECT description,genre,mov_lang,dir_name,stars from movie m,director d,rating r where d.dir_id=m.dir_id and r.mov_id=m.mov_id and mov_name='Dunkirk'; ";
81 mysqli_query($conn, $sql) or die('Error');
82 $result = mysqli_query($conn, $sql);
83 while($row=mysqli_fetch_array($result))
84 {
85 echo '<table style="margin-left:20%; margin-right:20%;">
86
87 <tr>
88 <td><u><b>Description</b></u></td>
89 <td>'.$row['description'].'</td>
90 </tr>
91 <tr>
92 <td><u><b> Genre</b></u></td>
93 <td>'.$row['genre'].'</td>
94 </tr>
95 <tr>
96 <td><u><b> Language </b></u></td>
97 <td>'.$row['mov_lang'].'</td>
98 </tr>
99 <tr>
100 <td><u><b> Director</b> </u></td>
101 <td>'.$row['dir_name'].'</td>
102 </tr>
103 <tr>
104 <td><u><b>Rating</b> </u></td>
105 <td>'.$row['stars'].'</td>
106 </tr>
107 </table><br><br><br>';
108 }
109 ?>
110
111 <h1 align="middle" style="font-size: 300%; color:white;"><br><b><u>Cast</u></b></h1>
112
113 <?php
114 $sql1="SELECT actor_name,role from actor a,movie m,movie_cast mc where a.actor_id=mc.actor_id and mc.mov_id=m.mov_id and m.mov_name='Dunkirk';";
115 mysqli_query($conn, $sql) or die('Error');
116 $result1 = mysqli_query($conn, $sql1);
117 echo '<br><table style="margin-left: auto; margin-right: auto;">
118 <tr align="middle">
119 <td><u><b>Actor</b></u></td>
120 <td><u><b>Role</b></u></td>
121 </tr>';
122 while($row=mysqli_fetch_array($result1))
123 {
124 echo '<tr>
125 <td>'.$row['actor_name'].'</td>
126 <td align="middle">'.$row['role'].'</td>
127 </tr>';
128 }
129
130 echo '</table><br><br><br>';
131
132 $_SESSION['mov_name']="Dunkirk";
133
134 ?>
135
136 <center><a href="nowshowing.php" class="btn btn-default btn-lg" style="font-size:15px padding-top:0.25%; font-family: comic sans ms; color: black" role="button"><b>Book now</b></a></center><br>
137
138 </body>
139
140
141 <?php
142 include_once 'footer.php';
143 ?>
144 </html>
